package vip.zhenzicheng.algorithm.leetcode.sql;

/**
 * <a href="https://leetcode.cn/problems/customers-who-never-order/">从不订购的客户 [简单]</a>
 *
 * @author zhenzicheng
 * @date 2022-06-30 15:18
 */
public class CustomersWhoNeverOrder_183 {

  /**
   * 左连接能会出现空，通过is找到null的数据
   */
  String sql1 = "select c.name as Customers from Customers c left join Orders o on c.id = o.customerId where customerId is null";
}
